• File: getprodid_json.php
  • Full Path: C:/htdocs/reeft_gps_test/REEFTintegrationLog/saved/getprodid_json.php
  • Date Modified: 04/30/2025 7:56 AM
  • File size: 13.35 KB
  • MIME-type: text/x-php
  • Charset: utf-8
<?php
//======================================================================================
//
// Function: Get all productions id per workcenter
// 
// Programmer: JJ
// Date      : 2022-03-10
//
// Copyright Reeft A/S (c) - 2022
//======================================================================================

$myJson = '{"header":{"reference":"Testline","currentDate":"2024-06-25","currentTime":"13:22:57","returnCode":"00","returnMsg":"Alles ist gut"},"detail":[{"wcName":"Testline_wc1","prodid_raw":"005210000042120001159867630069","prodid_pretty":"00521-000004212000115-9867630069","key":0,"ProdIDstatus":"0"},{"wcName":"Testline_wc2","prodid_raw":"0052142120001159867630069","prodid_pretty":"00521-4212000-1159867630","key":1,"ProdIDstatus":"0"},{"wcName":"Testline_wc3","prodid_raw":"0530042520027159873730110","prodid_pretty":"05300-4252002-7159873730","key":2,"ProdIDstatus":"0"},{"wcName":"Testline_wc4","prodid_raw":false,"prodid_pretty":"--","key":3,"ProdIDstatus":false},{"wcName":"Testline_wc5","prodid_raw":false,"prodid_pretty":"--","key":4,"ProdIDstatus":false},{"wcName":"Testline_wc6","prodid_raw":false,"prodid_pretty":"--","key":5,"ProdIDstatus":false},{"wcName":"Testline_wc7","prodid_raw":false,"prodid_pretty":"--","key":6,"ProdIDstatus":false},{"wcName":"Testline_wc8","prodid_raw":false,"prodid_pretty":"--","key":7,"ProdIDstatus":false},{"wcName":"Testline_wc9","prodid_raw":false,"prodid_pretty":"--","key":8,"ProdIDstatus":false},{"wcName":"Testline_wc10","prodid_raw":false,"prodid_pretty":"--","key":9,"ProdIDstatus":false},{"wcName":"Testline_wc11","prodid_raw":false,"prodid_pretty":"--","key":10,"ProdIDstatus":false},{"wcName":"Testline_wc12","prodid_raw":false,"prodid_pretty":"--","key":11,"ProdIDstatus":false},{"wcName":"Testline_wc13","prodid_raw":false,"prodid_pretty":"--","key":12,"ProdIDstatus":false},{"wcName":"Testline_wc14","prodid_raw":false,"prodid_pretty":"--","key":13,"ProdIDstatus":false},{"wcName":"Testline_wc15","prodid_raw":false,"prodid_pretty":"--","key":14,"ProdIDstatus":false},{"wcName":"Testline_wc16","prodid_raw":false,"prodid_pretty":"--","key":15,"ProdIDstatus":false}]}';


$myJson = '{
	"header": {
		"reference": "Testline",
		"currentDate": "2024-06-25",
		"currentTime": "13:22:57",
		"returnCode": "00",
		"returnMsg": "Alles ist gut"
	},
	"detail": [
		{
			"wcName": "Testline_wc1",
			"prodid_raw": "0052142420013159867630069",
			"prodid_pretty": "00521-4242001315-9867630069",
			"key": 0,
			"ProdIDstatus": "0"
		},
		{
			"wcName": "Testline_wc2",
			"prodid_raw": "0052142120001159867630069",
			"prodid_pretty": "00521-4212000115-9867630069",
			"key": 1,
			"ProdIDstatus": "0"
		},
		{
			"wcName": "Testline_wc3",
			"prodid_raw": "0530042520012159871830037",
			"prodid_pretty": "05300-4252001215-9871830037",
			"key": 2,
			"ProdIDstatus": "0"
		},
		{
			"wcName": "Testline_wc4",
			"prodid_raw": false,
			"prodid_pretty": "--",
			"key": 3,
			"ProdIDstatus": false
		},
		{
			"wcName": "Testline_wc5",
			"prodid_raw": false,
			"prodid_pretty": "--",
			"key": 4,
			"ProdIDstatus": false
		},
		{
			"wcName": "Testline_wc6",
			"prodid_raw": false,
			"prodid_pretty": "--",
			"key": 5,
			"ProdIDstatus": false
		},
		{
			"wcName": "Testline_wc7",
			"prodid_raw": false,
			"prodid_pretty": "--",
			"key": 6,
			"ProdIDstatus": false
		},
		{
			"wcName": "Testline_wc8",
			"prodid_raw": false,
			"prodid_pretty": "--",
			"key": 7,
			"ProdIDstatus": false
		},
		{
			"wcName": "Testline_wc9",
			"prodid_raw": false,
			"prodid_pretty": "--",
			"key": 8,
			"ProdIDstatus": false
		},
		{
			"wcName": "Testline_wc10",
			"prodid_raw": false,
			"prodid_pretty": "--",
			"key": 9,
			"ProdIDstatus": false
		},
		{
			"wcName": "Testline_wc11",
			"prodid_raw": false,
			"prodid_pretty": "--",
			"key": 10,
			"ProdIDstatus": false
		},
		{
			"wcName": "Testline_wc12",
			"prodid_raw": false,
			"prodid_pretty": "--",
			"key": 11,
			"ProdIDstatus": false
		},
		{
			"wcName": "Testline_wc13",
			"prodid_raw": false,
			"prodid_pretty": "--",
			"key": 12,
			"ProdIDstatus": false
		},
		{
			"wcName": "Testline_wc14",
			"prodid_raw": false,
			"prodid_pretty": "--",
			"key": 13,
			"ProdIDstatus": false
		},
		{
			"wcName": "Testline_wc15",
			"prodid_raw": false,
			"prodid_pretty": "--",
			"key": 14,
			"ProdIDstatus": false
		},
		{
			"wcName": "Testline_wc16",
			"prodid_raw": false,
			"prodid_pretty": "--",
			"key": 15,
			"ProdIDstatus": false
		}
	]
}';


echo $myJson;
exit;



if (isset($_REQUEST["reference"])) $reference = $_REQUEST["reference"]; 

//======================================================================================
// Check if user is logged in
//======================================================================================
include 'include/login-check.php';

//======================================================================================
// Get Line ID from session
//======================================================================================
//include "get_line_from_session.php";
//======================================================================================

//======================================================================================
// Connect to link script
//======================================================================================
include "include/web-connect.php";

//======================================================================================
// Main takt data
//======================================================================================
include "include/main_" . $reference . ".php";
include "include/tool-text.php";

//======================================================================================
// Language data
//======================================================================================
//include "language/" . $locale_info["DFT_LANGUAGE"] . ".php";
include "language/" . $locale_info["DFT_LANGUAGE"] . '_' .  $reference .  ".php";

//======================================================================================
// Set defaults
//======================================================================================
	$returnCode 					= '99';
	$returnMsg 						= 'No data found';

	$currentDate = date('Y-m-d');
	$currentTime = date('H:i:s');

//======================================================================================
// Set header
//======================================================================================

	header('Content-Type: application/json;charset=utf-8');

//======================================================================================


// Set defaults
$c = 1;
$reference  = $reference;
$loop = $locale_info["NBR_OF_WC"];
$input_max_length = $locale_info["DFT_PRODIDLEN"];
$input_size = $locale_info["DFT_PRODIDLEN"] + 3;

// Get current sound state
$extrenalURL = "";

$result = $conn->CreateRequest();
// Prod id
$result->AddParameter("refCode",$reference);
$result->AddParameter("Wc1ProdID","");
$result->AddParameter("Wc2ProdID","");
$result->AddParameter("Wc3ProdID","");
$result->AddParameter("Wc4ProdID","");
$result->AddParameter("Wc5ProdID","");
$result->AddParameter("Wc6ProdID","");
$result->AddParameter("Wc7ProdID","");
$result->AddParameter("Wc8ProdID","");
$result->AddParameter("Wc9ProdID","");
$result->AddParameter("Wc10ProdID","");
$result->AddParameter("Wc11ProdID","");
$result->AddParameter("Wc12ProdID","");
$result->AddParameter("Wc13ProdID","");
$result->AddParameter("Wc14ProdID","");
$result->AddParameter("Wc15ProdID","");
$result->AddParameter("Wc16ProdID","");

// Prod id status
$result->AddParameter("Wc1ProdStatus","");
$result->AddParameter("Wc2ProdStatus","");
$result->AddParameter("Wc3ProdStatus","");
$result->AddParameter("Wc4ProdStatus","");
$result->AddParameter("Wc5ProdStatus","");
$result->AddParameter("Wc6ProdStatus","");
$result->AddParameter("Wc7ProdStatus","");
$result->AddParameter("Wc8ProdStatus","");
$result->AddParameter("Wc9ProdStatus","");
$result->AddParameter("Wc10ProdStatus","");
$result->AddParameter("Wc11ProdStatus","");
$result->AddParameter("Wc12ProdStatus","");
$result->AddParameter("Wc13ProdStatus","");
$result->AddParameter("Wc14ProdStatus","");
$result->AddParameter("Wc15ProdStatus","");
$result->AddParameter("Wc16ProdStatus","");
$result->AddParameter("WcPassThrough","");

$result->AddParameter("BufferInProdID","");
$result->AddParameter("BufferOutProdID","");
$result->AddParameter("ParallelMode","");
$result->AddParameter("NextParallelMode","");
$result->AddParameter("ParallelTaktMultiplier","");

$result->AddRequest("script.getvars", "vars.");
if (!$result->Perform())
return;

$ProdID[0]	 = $result->GetValue("vars.result",0,"Wc1ProdID");
$ProdID[1]	 = $result->GetValue("vars.result",0,"Wc2ProdID");
$ProdID[2]	 = $result->GetValue("vars.result",0,"Wc3ProdID");
$ProdID[3]	 = $result->GetValue("vars.result",0,"Wc4ProdID");
$ProdID[4]	 = $result->GetValue("vars.result",0,"Wc5ProdID");
$ProdID[5]	 = $result->GetValue("vars.result",0,"Wc6ProdID");
$ProdID[6]	 = $result->GetValue("vars.result",0,"Wc7ProdID");
$ProdID[7]	 = $result->GetValue("vars.result",0,"Wc8ProdID");
$ProdID[8]	 = $result->GetValue("vars.result",0,"Wc9ProdID");
$ProdID[9]	 = $result->GetValue("vars.result",0,"Wc10ProdID");
$ProdID[10]	 = $result->GetValue("vars.result",0,"Wc11ProdID");
$ProdID[11]	 = $result->GetValue("vars.result",0,"Wc12ProdID");
$ProdID[12]	 = $result->GetValue("vars.result",0,"Wc13ProdID");
$ProdID[13]	 = $result->GetValue("vars.result",0,"Wc14ProdID");
$ProdID[14]	 = $result->GetValue("vars.result",0,"Wc15ProdID");
$ProdID[15]	 = $result->GetValue("vars.result",0,"Wc16ProdID");

$ProdIDstatus[0]	 = $result->GetValue("vars.result",0,"Wc1ProdStatus");
$ProdIDstatus[1]	 = $result->GetValue("vars.result",0,"Wc2ProdStatus");
$ProdIDstatus[2]	 = $result->GetValue("vars.result",0,"Wc3ProdStatus");
$ProdIDstatus[3]	 = $result->GetValue("vars.result",0,"Wc4ProdStatus");
$ProdIDstatus[4]	 = $result->GetValue("vars.result",0,"Wc5ProdStatus");
$ProdIDstatus[5]	 = $result->GetValue("vars.result",0,"Wc6ProdStatus");
$ProdIDstatus[6]	 = $result->GetValue("vars.result",0,"Wc7ProdStatus");
$ProdIDstatus[7]	 = $result->GetValue("vars.result",0,"Wc8ProdStatus");
$ProdIDstatus[8]	 = $result->GetValue("vars.result",0,"Wc9ProdStatus");
$ProdIDstatus[9]	 = $result->GetValue("vars.result",0,"Wc10ProdStatus");
$ProdIDstatus[10]	 = $result->GetValue("vars.result",0,"Wc11ProdStatus");
$ProdIDstatus[11]	 = $result->GetValue("vars.result",0,"Wc12ProdStatus");
$ProdIDstatus[12]	 = $result->GetValue("vars.result",0,"Wc13ProdStatus");
$ProdIDstatus[13]	 = $result->GetValue("vars.result",0,"Wc14ProdStatus");
$ProdIDstatus[14]	 = $result->GetValue("vars.result",0,"Wc15ProdStatus");
$ProdIDstatus[15]	 = $result->GetValue("vars.result",0,"Wc16ProdStatus");

$WcPassThrough	 	 = $result->GetValue("vars.result",0,"WcPassThrough");

$BufferInProdID	 = $result->GetValue("vars.result",0,"BufferInProdID");
$BufferOutProdID = $result->GetValue("vars.result",0,"BufferOutProdID");

	// Get some data
$ParallelMode = $result->GetValue("vars.result",0,"ParallelMode");
$NextParallelMode = $result->GetValue("vars.result",0,"NextParallelMode");
$ParallelTaktMultiplier = $result->GetValue("vars.result",0,"ParallelTaktMultiplier");

// Init
$aryDetail = array();

//echo "$reference <br>";


foreach($ProdID as $key => $value) {
	
	$inputString = $value;
	
	$nbr = $key + 1;
	
	$wcName = $reference . '_wc' . $nbr;
	
	$outputString = substr($inputString, 0, 5) . "-" . substr($inputString, 5, 7) . "-" . substr($inputString, 12, 10);
	
	//echo "$wcName -- $key -- $value -- $outputString<br>";
	
	$tmpRow = array();	
	
	$tmpRow['wcName']			= $wcName;
	$tmpRow['prodid_raw']		= $value;	
	$tmpRow['prodid_pretty']	= $outputString;
	$tmpRow['key']				= $key;	
	
	$tmpRow['ProdIDstatus']		= $ProdIDstatus[$key];	
	
	
	
	
	$aryDetail[] = $tmpRow;	
	
}

	//=================================================================================================
	// Return message - crap actually
	//=================================================================================================
	$returnCode 					= '00';
	$returnMsg 						= 'Alles ist gut';

	//=================================================================================================
	// Create header
	//=================================================================================================
	$aryHeader = array();
	$aryHeader["reference"]			= $reference;
	$aryHeader["currentDate"] 		= $currentDate;
	$aryHeader["currentTime"] 		= $currentTime;
	$aryHeader["returnCode"] 		= $returnCode;
	$aryHeader["returnMsg"] 		= $returnMsg;

	//=================================================================================================
	// Create array and prepare for json encoding
	//=================================================================================================
	$returnJson["header"] 		= $aryHeader;
	$returnJson["detail"] 		= $aryDetail;

	//======================================================================================
	// Paint it black
	//======================================================================================
	echo(json_encode($returnJson));

?>